---
title: "SQL-040 to SQL-119: Read operations — business objects and collections"
summary: Retrieve operations for business objects and collections (excludes code-table reads, documented separately).
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SQL-040 to SQL-119: Read operations — business objects and collections

This page documents all 80 Read-type SQL operations for business objects and collections (SQL-040 through SQL-119). Code-table read statements (SQL-120 through SQL-150) are documented on a separate page. Stored-procedure reads have their body retrieval marked unavailable for this run (Legends CLI offline); see [Procedures](../procedures/index.md).

## SQL-040 clsAcknowledgeList.GetList

`clsAcknowledgeList.GetList` — stored procedure call retrieving from `pk80001_legalnet.getAcknowledgeList`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-040 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAcknowledgeList` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getAcknowledgeList(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsAcknowledgeList.vb`

---
## SQL-041 clsAppeal.Criteria.RetrieveSQL

`clsAppeal.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getAppeal`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-041 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppeal` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getAppeal(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb`

---
## SQL-042 clsAppealExtension collection

`clsAppealExtension collection` — stored procedure call retrieving from `pk80001_legalnet.getAppeal (extension cursor)`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-042 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppealExtension collection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getAppeal (extension cursor)(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb`

---
## SQL-043 clsAssignmentProcess.CalendarReview

`clsAssignmentProcess.CalendarReview` — stored procedure call retrieving from `pk80005_assignment.CalendarReview`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-043 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.CalendarReview(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-044 clsAssignmentProcess.calendar_review

`clsAssignmentProcess.calendar_review` — stored procedure call retrieving from `pk80005_assignment.calendar_review`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-044 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.calendar_review(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-045 clsAssignmentProcess.get_assign_list

`clsAssignmentProcess.get_assign_list` — stored procedure call retrieving from `pk80005_assignment.get_assign_list`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-045 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.get_assign_list(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-046 clsAssignmentProcess.get_assign_results

`clsAssignmentProcess.get_assign_results` — stored procedure call retrieving from `pk80005_assignment.get_assign_results`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-046 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.get_assign_results(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-047 clsAssignmentProcess.get_results

`clsAssignmentProcess.get_results` — stored procedure call retrieving from `pk80005_assignment.get_results`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-047 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.get_results(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-048 clsAssignmentProcess.max_result_seq

`clsAssignmentProcess.max_result_seq` — stored procedure call retrieving from `pk80005_assignment.max_result_seq`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-048 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.max_result_seq(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-049 clsAssignmentProcess.getOutlookFields

`clsAssignmentProcess.getOutlookFields` — stored procedure call retrieving from `pk80005_assignment.getOutlookFields`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-049 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.getOutlookFields(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-050 clsAssignmentProcess.getConsolFileLocation

`clsAssignmentProcess.getConsolFileLocation` — stored procedure call retrieving from `pk80005_assignment.getConsolFileLocation`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-050 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAssignmentProcess` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.getConsolFileLocation(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`

---
## SQL-051 clsAttorneyConflict.Criteria.RetrieveSQL

`clsAttorneyConflict.Criteria.RetrieveSQL` — inline SELECT retrieving from `ATTORNEY_CONFLICT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-051 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyConflict` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_CONFLICT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_CONFLICT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-052 clsAttorneyConflictCollection.GetAttorneyConflicts

`clsAttorneyConflictCollection.GetAttorneyConflicts` — inline SELECT retrieving from `ATTORNEY_CONFLICT + joins`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-052 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyConflictCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | SELECT | See Sample SQL below |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | See Sample SQL below |
| [PROVIDER_LOCATION](../database-tables.md#provider_location) | SELECT | See Sample SQL below |
| [POLICY](../database-tables.md#policy) | SELECT | See Sample SQL below |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_CONFLICT + joins
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_CONFLICT + joins in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-053 clsAttorneyConflict.getAttorneyConflictHearings

`clsAttorneyConflict.getAttorneyConflictHearings` — stored procedure call retrieving from `pk80005_assignment.getAttorneyConflictHearings`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-053 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyConflict` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.getAttorneyConflictHearings(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-054 clsAttorneyConflict.getAttorneyPastHearings

`clsAttorneyConflict.getAttorneyPastHearings` — stored procedure call retrieving from `pk80005_assignment.getAttorneyPastHearings`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-054 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyConflict` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.getAttorneyPastHearings(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-055 clsAttorneyPolicyAssignment.Criteria.RetrieveSQL

`clsAttorneyPolicyAssignment.Criteria.RetrieveSQL` — inline SELECT retrieving from `ATTORNEY_POLICY_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-055 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyPolicyAssignment` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_POLICY_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_POLICY_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---
## SQL-056 clsAttorneyPolicyAssignmentCollection.GetAttorneyPolicyAssignments

`clsAttorneyPolicyAssignmentCollection.GetAttorneyPolicyAssignments` — inline SELECT retrieving from `ATTORNEY_POLICY_ASSIGNMENT + joins`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-056 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyPolicyAssignmentCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | SELECT | See Sample SQL below |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | See Sample SQL below |
| [POLICY](../database-tables.md#policy) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_POLICY_ASSIGNMENT + joins
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_POLICY_ASSIGNMENT + joins in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---
## SQL-057 clsAttorneyProfile.Criteria.RetrieveSQL

`clsAttorneyProfile.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getAttyProfile`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-057 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyProfile` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getAttyProfile(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb`

---
## SQL-058 clsAttorneyProfile (qualified read)

`clsAttorneyProfile (qualified read)` — inline SELECT retrieving from `legal.attorney_profile`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-058 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyProfile (qualified read)` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL.ATTORNEY_PROFILE](../database-tables.md#legalattorney_profile) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against legal.attorney_profile
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against legal.attorney_profile in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb:587`

---
## SQL-059 clsAttorneySchedule.Criteria.RetrieveSQL

`clsAttorneySchedule.Criteria.RetrieveSQL` — inline SELECT retrieving from `ATTORNEY_SCHEDULE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-059 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneySchedule` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_SCHEDULE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_SCHEDULE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---
## SQL-060 clsAttorneyScheduleCollection.GetAttorneySchedules

`clsAttorneyScheduleCollection.GetAttorneySchedules` — inline SELECT retrieving from `ATTORNEY_SCHEDULE + ADP_EMPLOYEE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-060 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyScheduleCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | SELECT | See Sample SQL below |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_SCHEDULE + ADP_EMPLOYEE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_SCHEDULE + ADP_EMPLOYEE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---
## SQL-061 clsAttorneySchedule.getAttorneyScheduleConflict

`clsAttorneySchedule.getAttorneyScheduleConflict` — stored procedure call retrieving from `pk80005_assignment.getAttorneyScheduleConflict`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-061 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneySchedule` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80005_assignment.getAttorneyScheduleConflict(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---
## SQL-062 clsAttorneyWorkerAssignment.Criteria.RetrieveSQL

`clsAttorneyWorkerAssignment.Criteria.RetrieveSQL` — inline SELECT retrieving from `ATTORNEY_WORKER_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-062 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyWorkerAssignment` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_WORKER_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_WORKER_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-063 clsAttorneyWorkerAssignmentCollection.GetAttorneyWorkerAssignments

`clsAttorneyWorkerAssignmentCollection.GetAttorneyWorkerAssignments` — inline SELECT retrieving from `ATTORNEY_WORKER_ASSIGNMENT + ADP_EMPLOYEE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-063 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyWorkerAssignmentCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | SELECT | See Sample SQL below |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against ATTORNEY_WORKER_ASSIGNMENT + ADP_EMPLOYEE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against ATTORNEY_WORKER_ASSIGNMENT + ADP_EMPLOYEE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-064 clsAttorneyWorkerAssignment.GetWorkerAtty

`clsAttorneyWorkerAssignment.GetWorkerAtty` — stored procedure call retrieving from `pk80001_legalnet.GetWorkerAtty`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-064 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyWorkerAssignment` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.GetWorkerAtty(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-065 clsAttorneyWorkerAssignment.getWrkrAssignedAtty

`clsAttorneyWorkerAssignment.getWrkrAssignedAtty` — stored procedure call retrieving from `pk80001_legalnet.getWrkrAssignedAtty`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-065 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyWorkerAssignment` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getWrkrAssignedAtty(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-066 clsBoardLog.GetBoardLog

`clsBoardLog.GetBoardLog` — stored procedure call retrieving from `pk80001_legalnet.getBoardLog`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-066 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsBoardLog` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getBoardLog(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsBoardLog.vb`

---
## SQL-067 clsCaseCost.Criteria.RetrieveSQL

`clsCaseCost.Criteria.RetrieveSQL` — inline SELECT retrieving from `CASE_COST`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-067 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseCost` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_COST](../database-tables.md#case_cost) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against CASE_COST in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`

---
## SQL-068 clsCaseCostCollection.Criteria.MyRetrieveSQL

`clsCaseCostCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `CASE_COST`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-068 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseCostCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_COST](../database-tables.md#case_cost) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against CASE_COST in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb:924`

---
## SQL-069 clsCaseNote.Criteria.RetrieveSQL

`clsCaseNote.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.GetCaseNote`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-069 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseNote` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.GetCaseNote(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb`

---
## SQL-070 clsCaseOutcome.Criteria.RetrieveSQL

`clsCaseOutcome.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.GetCaseOutcome`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-070 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseOutcome` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.GetCaseOutcome(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb`

---
## SQL-071 clsCaseOutcomeCollection.Criteria.MyRetrieveSQL

`clsCaseOutcomeCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `CASE_OUTCOME cursor projection`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-071 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseOutcomeCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Read against CASE_OUTCOME cursor projection
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against CASE_OUTCOME cursor projection in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb:722`

---
## SQL-072 clsCaseSearch.CaseSearch

`clsCaseSearch.CaseSearch` — stored procedure call retrieving from `pk80001_legalnet.CaseSearch`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-072 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseSearch` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.CaseSearch(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseSearch.vb`

---
## SQL-073 clsCaseSearch.findCase

`clsCaseSearch.findCase` — stored procedure call retrieving from `pk80001_legalnet.findCase`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-073 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseSearch` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.findCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseSearch.vb`

---
## SQL-074 clsCaseStatusHistory.Criteria.RetrieveSQL

`clsCaseStatusHistory.Criteria.RetrieveSQL` — inline SELECT retrieving from `CASE_STATUS_HISTORY`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-074 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseStatusHistory` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against CASE_STATUS_HISTORY in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`

---
## SQL-075 clsCaseStatusHistoryCollection.Criteria.MyRetrieveSQL

`clsCaseStatusHistoryCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `CASE_STATUS_HISTORY`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-075 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseStatusHistoryCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against CASE_STATUS_HISTORY in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb:501`

---
## SQL-076 clsConsolidations.getConsolidatedCases

`clsConsolidations.getConsolidatedCases` — stored procedure call retrieving from `pk80001_legalnet.getConsolidatedCases`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-076 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsConsolidations` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getConsolidatedCases(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb`

---
## SQL-077 clsConsolidations.checkOtherCases

`clsConsolidations.checkOtherCases` — stored procedure call retrieving from `pk80001_legalnet.checkOtherCases`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-077 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsConsolidations` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.checkOtherCases(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb`

---
## SQL-078 clsCreateFile.createFileList

`clsCreateFile.createFileList` — stored procedure call retrieving from `pk80001_legalnet.createFileList`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-078 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCreateFile` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.createFileList(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsCreateFile.vb`

---
## SQL-079 clsHearingLocation.Criteria.RetrieveSQL

`clsHearingLocation.Criteria.RetrieveSQL` — inline SELECT retrieving from `HEARING_LOCATION + HEARING_LOCATION_CODE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-079 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocation` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | SELECT | See Sample SQL below |
| [HEARING_LOCATION_CODE](../database-tables.md#hearing_location_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against HEARING_LOCATION + HEARING_LOCATION_CODE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against HEARING_LOCATION + HEARING_LOCATION_CODE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---
## SQL-080 clsHearingLocationCollection.GetHearingLocations

`clsHearingLocationCollection.GetHearingLocations` — inline SELECT retrieving from `HEARING_LOCATION + HEARING_LOCATION_CODE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-080 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocationCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | SELECT | See Sample SQL below |
| [HEARING_LOCATION_CODE](../database-tables.md#hearing_location_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against HEARING_LOCATION + HEARING_LOCATION_CODE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against HEARING_LOCATION + HEARING_LOCATION_CODE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---
## SQL-081 clsHearingLocation.CanDeleteLocation

`clsHearingLocation.CanDeleteLocation` — inline SELECT retrieving from `SCHEDULE count guard`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-081 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocation` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [SCHEDULE](../database-tables.md#schedule) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against SCHEDULE count guard
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against SCHEDULE count guard in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---
## SQL-082 clsHearingLocationInfo.Criteria.RetrieveSQL

`clsHearingLocationInfo.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getHearingInfo`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-082 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsHearingLocationInfo` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getHearingInfo(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb`

---
## SQL-083 clsHearingLocationInfoCollection.Criteria.MyRetrieveSQL

`clsHearingLocationInfoCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-083 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocationInfoCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb:860`

---
## SQL-084 clsHearingLocationInfo.get_hearingID

`clsHearingLocationInfo.get_hearingID` — stored procedure call retrieving from `pk80001_legalnet.get_hearingID`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-084 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsHearingLocationInfo` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.get_hearingID(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb`

---
## SQL-085 clsImageAlerts.SelectImageAlertsHist

`clsImageAlerts.SelectImageAlertsHist` — stored procedure call retrieving from `pk80001_legalnet.SelectImageAlertsHist`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-085 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsImageAlerts` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.SelectImageAlertsHist(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsImageAlerts.vb`

---
## SQL-086 clsLegalCase.Criteria.RetrieveSQL

`clsLegalCase.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getLegalCase`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-086 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getLegalCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-087 clsLegalCase.get_asgn_atty

`clsLegalCase.get_asgn_atty` — stored procedure call retrieving from `pk80001_legalnet.get_asgn_atty`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-087 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.get_asgn_atty(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-088 clsLegalCase.get_case_issue_text

`clsLegalCase.get_case_issue_text` — stored procedure call retrieving from `pk80001_legalnet.get_case_issue_text`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-088 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.get_case_issue_text(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-089 clsLegalCaseEmployer.Criteria.RetrieveSQL

`clsLegalCaseEmployer.Criteria.RetrieveSQL` — inline SELECT retrieving from `LEGAL_CASE_EMPLOYER + OTHER_FIRM x2 + LEGAL_PERSON`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-089 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalCaseEmployer` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | SELECT | See Sample SQL below |
| [OTHER_FIRM](../database-tables.md#other_firm) | SELECT | See Sample SQL below |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_CASE_EMPLOYER + OTHER_FIRM x2 + LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_CASE_EMPLOYER + OTHER_FIRM x2 + LEGAL_PERSON in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb`

---
## SQL-090 clsLegalCaseEmployerCollection retrieve

`clsLegalCaseEmployerCollection retrieve` — inline SELECT retrieving from `LEGAL_CASE_EMPLOYER + joins`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-090 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalCaseEmployerCollection retrieve` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | SELECT | See Sample SQL below |
| [OTHER_FIRM](../database-tables.md#other_firm) | SELECT | See Sample SQL below |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_CASE_EMPLOYER + joins
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_CASE_EMPLOYER + joins in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb`

---
## SQL-091 clsLegalCaseEvaluation.Criteria.RetrieveSQL

`clsLegalCaseEvaluation.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getLCE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-091 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCaseEvaluation` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getLCE(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb`

---
## SQL-092 clsLegalCaseEvaluationCollection.Criteria.MyRetrieveSQL

`clsLegalCaseEvaluationCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `LEGAL_CASE_EVALUATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-092 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalCaseEvaluationCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EVALUATION](../database-tables.md#legal_case_evaluation) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_CASE_EVALUATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_CASE_EVALUATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb:600`

---
## SQL-093 clsLegalFileLocation.Criteria.RetrieveSQL

`clsLegalFileLocation.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getFileLocation`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-093 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalFileLocation` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getFileLocation(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`

---
## SQL-094 clsLegalFileLocationCollection.Criteria.MyRetrieveSQL

`clsLegalFileLocationCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `LEGAL_FILE_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-094 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalFileLocationCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_FILE_LOCATION](../database-tables.md#legal_file_location) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_FILE_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_FILE_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb:616`

---
## SQL-095 clsLegalPerson.Criteria.RetrieveSQL

`clsLegalPerson.Criteria.RetrieveSQL` — inline SELECT retrieving from `LEGAL_PERSON`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-095 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPerson` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_PERSON in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---
## SQL-096 clsLegalPersonCollection.GetLegalPersons

`clsLegalPersonCollection.GetLegalPersons` — inline SELECT retrieving from `LEGAL_PERSON`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-096 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_PERSON in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---
## SQL-097 clsLegalPerson delete-guard

`clsLegalPerson delete-guard` — inline SELECT retrieving from `SUBPOENA_RECIPIENT (NOT EXISTS)`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-097 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPerson delete-guard` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [SUBPOENA_RECIPIENT](../database-tables.md#subpoena_recipient) | SELECT | See Sample SQL below |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against SUBPOENA_RECIPIENT (NOT EXISTS)
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against SUBPOENA_RECIPIENT (NOT EXISTS) in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---
## SQL-098 clsLegalPersonList.GetLegalPersonList

`clsLegalPersonList.GetLegalPersonList` — inline SELECT retrieving from `LEGAL_PERSON + LEGAL_PERSON_TYPE + LEGAL_PERSON_TYPE_CODE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-098 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonList` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | SELECT | See Sample SQL below |
| [LEGAL_PERSON_TYPE_CODE](../database-tables.md#legal_person_type_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_PERSON + LEGAL_PERSON_TYPE + LEGAL_PERSON_TYPE_CODE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_PERSON + LEGAL_PERSON_TYPE + LEGAL_PERSON_TYPE_CODE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonList.vb`

---
## SQL-099 clsLegalPersonType.Criteria.RetrieveSQL

`clsLegalPersonType.Criteria.RetrieveSQL` — inline SELECT retrieving from `LEGAL_PERSON_TYPE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-099 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonType` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_PERSON_TYPE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_PERSON_TYPE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`

---
## SQL-100 clsLegalPersonTypeCollection.GetLegalPersonTypes

`clsLegalPersonTypeCollection.GetLegalPersonTypes` — inline SELECT retrieving from `LEGAL_PERSON_TYPE + LEGAL_PERSON + code table`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-100 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonTypeCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | SELECT | See Sample SQL below |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | See Sample SQL below |
| [LEGAL_PERSON_TYPE_CODE](../database-tables.md#legal_person_type_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_PERSON_TYPE + LEGAL_PERSON + code table
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_PERSON_TYPE + LEGAL_PERSON + code table in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`

---
## SQL-101 clsLegalSchedule.Criteria.RetrieveSQL

`clsLegalSchedule.Criteria.RetrieveSQL` — stored procedure call retrieving from `pk80001_legalnet.getSchedule`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-101 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalSchedule` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getSchedule(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`

---
## SQL-102 clsLetterRequest case lookup

`clsLetterRequest case lookup` — inline SELECT retrieving from `LEGAL.vw_cases`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-102 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLetterRequest case lookup` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL.VW_CASES](../database-tables.md#legalvw_cases) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL.vw_cases
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL.vw_cases in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:730`

---
## SQL-103 clsLetterRequest.SelectLetterRequests

`clsLetterRequest.SelectLetterRequests` — stored procedure call retrieving from `pk82289_legalnet_letters.SelectLetterRequests`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-103 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLetterRequest` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk82289_legalnet_letters.SelectLetterRequests(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:1197`

---
## SQL-104 clsLetterRequest.SelectLetter

`clsLetterRequest.SelectLetter` — stored procedure call retrieving from `pk82289_legalnet_letters.SelectLetter`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-104 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLetterRequest` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk82289_legalnet_letters.SelectLetter(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:1203`

---
## SQL-105 clsLetterRequest.GetWorkerInfo

`clsLetterRequest.GetWorkerInfo` — stored procedure call retrieving from `pk82289_legalnet_letters.GetWorkerInfo`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-105 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLetterRequest` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk82289_legalnet_letters.GetWorkerInfo(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb:1211`

---
## SQL-106 clsMailDate.mailDateList

`clsMailDate.mailDateList` — stored procedure call retrieving from `pk80001_legalnet.mailDateList`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-106 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsMailDate` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.mailDateList(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsMailDate.vb`

---
## SQL-107 clsOtherFirm.Criteria.RetrieveSQL

`clsOtherFirm.Criteria.RetrieveSQL` — inline SELECT retrieving from `OTHER_FIRM`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-107 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherFirm` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OTHER_FIRM](../database-tables.md#other_firm) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OTHER_FIRM
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OTHER_FIRM in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`

---
## SQL-108 clsOtherFirmCollection.GetOtherFirms

`clsOtherFirmCollection.GetOtherFirms` — inline SELECT retrieving from `OTHER_FIRM + OTHER_FIRM_TYPE_CODE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-108 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherFirmCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OTHER_FIRM](../database-tables.md#other_firm) | SELECT | See Sample SQL below |
| [OTHER_FIRM_TYPE_CODE](../database-tables.md#other_firm_type_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OTHER_FIRM + OTHER_FIRM_TYPE_CODE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OTHER_FIRM + OTHER_FIRM_TYPE_CODE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`

---
## SQL-109 clsOtherLegalParty.Criteria.RetrieveSQL

`clsOtherLegalParty.Criteria.RetrieveSQL` — inline SELECT retrieving from `LEGAL_CASE_EMPLOYER + joins`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-109 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherLegalParty` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_CASE_EMPLOYER + joins
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_CASE_EMPLOYER + joins in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb`

---
## SQL-110 clsOtherLegalPartyCollection.Criteria.MyRetrieveSQL

`clsOtherLegalPartyCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `LEGAL_CASE_EMPLOYER + joins`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-110 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherLegalPartyCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against LEGAL_CASE_EMPLOYER + joins
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against LEGAL_CASE_EMPLOYER + joins in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb:673`

---
## SQL-111 clsOutcomeIssue.Criteria.RetrieveSQL

`clsOutcomeIssue.Criteria.RetrieveSQL` — inline SELECT retrieving from `OUTCOME_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-111 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeIssue` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OUTCOME_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OUTCOME_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`

---
## SQL-112 clsOutcomeIssueCollection.Criteria.MyRetrieveSQL

`clsOutcomeIssueCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `OUTCOME_ISSUE + OUTCOME_ISSUE_CODE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-112 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeIssueCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | SELECT | See Sample SQL below |
| [OUTCOME_ISSUE_CODE](../database-tables.md#outcome_issue_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OUTCOME_ISSUE + OUTCOME_ISSUE_CODE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OUTCOME_ISSUE + OUTCOME_ISSUE_CODE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb:740`

---
## SQL-113 clsOutcomeStaff.Criteria.RetrieveSQL

`clsOutcomeStaff.Criteria.RetrieveSQL` — inline SELECT retrieving from `OUTCOME_STAFF`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-113 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeStaff` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_STAFF](../database-tables.md#outcome_staff) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OUTCOME_STAFF in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb`

---
## SQL-114 clsOutcomeStaffCollection.Criteria.MyRetrieveSQL

`clsOutcomeStaffCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `OUTCOME_STAFF`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-114 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeStaffCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_STAFF](../database-tables.md#outcome_staff) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OUTCOME_STAFF in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb:565`

---
## SQL-115 clsOutOFTownRotationAssgn.Criteria.RetrieveSQL

`clsOutOFTownRotationAssgn.Criteria.RetrieveSQL` — inline SELECT retrieving from `OUT_OF_TOWN_ROTATION_ASSGN`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-115 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutOFTownRotationAssgn` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OUT_OF_TOWN_ROTATION_ASSGN
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OUT_OF_TOWN_ROTATION_ASSGN in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`

---
## SQL-116 clsOutOFTownRotationAssgnCollection.GetOutOfTownRotationAssgns

`clsOutOFTownRotationAssgnCollection.GetOutOfTownRotationAssgns` — inline SELECT retrieving from `OUT_OF_TOWN_ROTATION_ASSGN + ADP_EMPLOYEE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-116 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutOFTownRotationAssgnCollection` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | SELECT | See Sample SQL below |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against OUT_OF_TOWN_ROTATION_ASSGN + ADP_EMPLOYEE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against OUT_OF_TOWN_ROTATION_ASSGN + ADP_EMPLOYEE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`

---
## SQL-117 clsRequestIssue.Criteria.RetrieveSQL

`clsRequestIssue.Criteria.RetrieveSQL` — inline SELECT retrieving from `REQUEST_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-117 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsRequestIssue` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUEST_ISSUE](../database-tables.md#request_issue) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against REQUEST_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against REQUEST_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`

---
## SQL-118 clsRequestIssueCollection.Criteria.MyRetrieveSQL

`clsRequestIssueCollection.Criteria.MyRetrieveSQL` — inline SELECT retrieving from `REQUEST_ISSUE + REQUEST_ISSUE_CODE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-118 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsRequestIssueCollection` |
| **Criteria property** | `MyRetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUEST_ISSUE](../database-tables.md#request_issue) | SELECT | See Sample SQL below |
| [REQUEST_ISSUE_CODE](../database-tables.md#request_issue_code) | SELECT | See Sample SQL below |

### Sample SQL

```sql
-- Read against REQUEST_ISSUE + REQUEST_ISSUE_CODE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Read statements against REQUEST_ISSUE + REQUEST_ISSUE_CODE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb:549`

---
## SQL-119 clsSAIFAttorney.getSAIFAtty

`clsSAIFAttorney.getSAIFAtty` — stored procedure call retrieving from `pk80001_legalnet.getSAIFAtty`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-119 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsSAIFAttorney` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeRetrieve` (or equivalent collection-load method) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.getSAIFAtty(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- See per-SQL-ID Sources subsections above for exact .vb file/line citations.